SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415530 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415530 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912640,239723,1003043,1026974,714925,708090,62172,612336,524786,98630,179682,719210,617558,125633,841429,44689,671976,38718,332368,375,313873,456949,744555,285533,660073,72141,171583,254794,828998,833886,420153,464344,901528,560111,860681,317873,94829,504612,510035,233250,88534,217357,209412,221819,755548,333804,58208,1033585,396620,370148,294107,119984,674985,1016821,55600,559978,998219,906224,184774,539031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]