SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534014 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534014 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249056,662127,272828,336601,49877,801264,975807,268483,753610,963058,776284,136864,95604,444926,372595,946105,476124,407506,641145,932661,890880,1048676,1038401,1045693,623523,278687,339259,691508,459547,967828,931325,954604,16250,430693,655218,448853,141064,374612,875423,321575,485547,631362,254168,1043380,456018,527169,649123,767955,474313,762673,622066,621170,810739,521553,504451,198715,565752,207288,147860,430973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]