SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019057 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019057 [ RunTime:0.002154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55174,991225,357886,567426,137319,110583,988382,786116,60772,134608,151317,846871,1001171,117853,799986,387469,602596,955790,725094,125764,518294,498459,958553,619900,568717,532197,849006,225110,801500,137974,823120,104157,820430,285714,151191,49470,140023,968928,331151,1990,453417,755055,674995,477074,357133,73532,128164,1041044,846440,794922,780470,9980,974220,824989,742271,417145,382731,267639,408790,223760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]