SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037847 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037847 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936197,755908,927740,823124,971747,352998,153734,402484,494295,727503,235673,503308,913883,477673,550482,415820,622393,433432,52734,280389,200920,330360,718867,318429,167,446410,327338,815912,356364,424741,558536,574221,216387,231055,582950,126724,207172,245351,1046400,340653,71867,578582,30823,485674,962987,1044678,82894,380777,15072,1029938,847050,350356,542661,115447,553653,37637,654602,853277,448260,460757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]