SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419963 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419963 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391432,232174,426804,679129,942517,450344,308593,1033645,445096,134358,597716,909567,992323,328963,42660,900010,59592,933886,809897,393964,171920,902538,404635,118589,279930,546921,585451,1032855,550396,590896,273713,490805,813282,878103,936791,297987,31987,486950,1032228,1000188,79533,345701,556199,148090,712535,11469,250403,557385,758926,980940,617019,731657,752935,1006441,11544,912014,599626,242816,513735,495269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]