SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455251 LIMIT 1 [ RunTime:0.000566s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455251 [ RunTime:0.002140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437259,767077,92456,69392,549272,149485,920287,768986,121440,655724,847122,139719,103431,449729,921419,203369,167433,499571,600480,230564,825167,1029278,885167,1009114,417422,747712,579384,114194,133282,229968,409063,969671,476952,291614,897798,960542,1043570,738564,497767,1047775,357997,690284,381478,122483,11227,409095,531257,689011,371859,668782,377910,981328,842683,447411,1006349,678572,111087,318419,1012429,367105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006771s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001947s ]