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` = 1026222 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026222 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186772,264112,739186,591316,336894,704805,967849,661077,65278,247919,135698,269387,954032,338113,743889,618830,2289,268314,953272,604646,769294,731041,88062,587699,442233,391111,4230,839680,504432,911998,922641,757842,35729,323024,1047357,806170,979171,365559,851221,197729,986263,900606,42729,844271,893828,831740,211083,627819,79307,931961,1028571,666909,595944,539069,931120,71121,837180,699156,977180,724401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001744s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]