SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046084 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046084 [ RunTime:0.002667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917207,155298,69316,275088,46858,879643,469551,921143,841385,1027977,903238,947315,371009,356454,562209,652718,144669,80845,750833,241599,529751,207244,844835,1011167,335102,546417,853933,88262,923691,585714,31162,1025300,473181,595986,70674,524206,351091,277047,806428,218951,249045,956121,501399,604762,870031,556559,720090,974795,1042893,129103,646311,438313,147913,891934,965842,385387,131344,827021,376942,30352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]