SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481745 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481745 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156964,341722,1033728,365114,512986,670158,317966,625589,366748,914710,309237,828747,657268,156568,555459,341084,545947,918337,926775,939619,519379,670129,834765,1043705,651299,104812,33682,50953,806800,625893,950560,757833,727051,26224,283141,33751,793661,88689,55422,171215,1000567,62429,948885,998719,669733,185542,433613,243771,747871,795891,39580,890437,460467,363364,223101,1031466,71975,54618,836669,807194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481745 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481745 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002996s ]