SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004464s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017844 LIMIT 1 [ RunTime:0.000653s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017844 [ RunTime:0.007352s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681296,426574,969330,819379,1016207,662299,970630,327829,28455,991882,1046228,49410,838982,128891,558088,695412,725325,57722,10097,277789,697285,905946,469580,663528,440143,253888,449793,774711,638438,138773,137815,130368,184133,955266,23866,672389,505445,522790,142373,540331,145582,927068,289917,99246,873470,429983,995850,666187,404570,537501,1003078,907654,478183,809634,349111,257629,420740,28268,621403,166919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]