SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042187 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042187 [ RunTime:0.004396s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410901,943901,66368,683567,1024066,664441,953193,665,219988,289077,704935,468378,511955,146204,561055,448052,874840,1020479,533505,459266,456467,565035,120399,884222,86451,119268,491891,833909,706463,563381,737083,535039,304649,226283,481870,590559,298139,885224,137715,102693,2935,136340,554215,824793,540353,657670,34797,606397,147178,603377,490834,494398,984876,212744,563166,534839,271561,486823,384150,428003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]