SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435791 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435791 [ RunTime:0.001950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011939,491314,1037095,862915,311026,809216,217913,738281,316484,178576,111528,484839,939391,824997,732883,797072,997257,37514,743542,530219,27547,41510,992906,822767,681262,221893,591848,844213,573487,435283,404127,570035,169603,454659,24712,413555,486836,51485,561101,571511,404246,36508,514364,132276,475664,115654,845898,888196,710407,429745,357321,601941,926854,178650,47950,452276,245934,852399,678002,848122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]