SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001513s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 246018 LIMIT 1 [ RunTime:0.000630s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 246018 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105226,10032,383810,452858,364470,536632,660857,120048,93393,327107,679416,556712,698232,960709,42720,501816,269877,636269,49979,384400,934686,155427,387386,182093,677398,681844,1014493,790222,437994,255005,87430,610962,553737,693488,864558,1005705,718278,712068,1022101,311492,331994,381843,627825,168473,59466,420572,1047065,675602,22617,86823,210702,612768,835882,712316,193580,1026776,708175,638071,671552,931044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 246018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 246018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]