SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001692s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255451 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255451 [ RunTime:0.002709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325774,295595,25597,724597,948651,296631,893981,390658,832081,179192,958410,136163,138908,961638,253100,204846,1017087,372891,715758,11382,170874,764677,310445,130466,666560,1009846,571973,235985,827346,1024695,453427,221346,498444,432057,589263,975019,122806,651527,457453,108869,131134,394157,663523,973734,1019999,330003,20481,671280,153625,336702,592080,46495,954348,758412,233123,274083,50301,58465,511706,840107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001787s ]