SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28805 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28805 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429851,139882,498238,259816,1008343,734466,872537,879190,8078,299503,144714,282530,294906,298775,714505,392748,638917,630411,99083,501660,214147,424288,861916,653268,65388,370667,642236,929473,953941,698258,830233,504120,1048326,798956,21934,926848,469163,710206,541096,334227,11934,129359,1024645,196993,594113,127245,652895,47989,464980,995608,850113,415913,947058,621161,272004,152318,142025,656877,271815,312980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001450s ]