SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002710s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434400 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434400 [ RunTime:0.002349s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401082,405565,784636,164312,928559,359220,619349,283860,763802,846123,603258,121614,810041,334251,476717,643864,77303,521132,312650,1016955,831862,203734,852958,321764,283081,166059,638141,434722,484752,369815,934540,645481,705822,425222,227971,334424,647661,409348,516794,25998,362832,228144,241106,959381,597094,828059,274627,557878,54861,756465,151339,104941,212851,617453,5195,364187,235683,51178,32875,104920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]