SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568041 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568041 [ RunTime:0.003012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119476,700914,929636,1034561,882579,1030576,990869,71798,805765,737836,299534,371790,764564,553294,554194,384341,590542,317487,41840,1022643,261581,441595,335669,692103,398355,249626,884959,331570,587324,121416,668740,1018908,33579,411928,970500,655808,31503,966488,226048,409876,995786,749965,324400,189435,368358,549449,32852,622249,951161,188567,832981,608762,86680,676853,797154,517216,703504,626827,420731,777549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]