SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433481 LIMIT 1 [ RunTime:0.000537s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433481 [ RunTime:0.002559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477836,320668,244209,119482,526890,569944,69530,873528,462941,117543,1027380,333748,132365,206868,564299,1009455,410122,106471,552750,171521,621876,104101,111840,656073,380703,45501,936730,584643,696336,840572,278274,705730,400788,310667,72523,100541,582315,119584,655254,662953,282310,350710,849783,591996,445971,427292,166269,716189,568320,12097,91713,643708,659247,901351,722589,30020,314625,833178,87986,895098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]