SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402212 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402212 [ RunTime:0.002314s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25648,1010593,689187,226068,199488,414216,929045,664435,609472,354169,409496,928401,494047,733958,687078,1017587,930206,611391,540300,847821,474298,1014055,226379,443413,376173,951964,549258,477081,249484,401420,86911,426474,640034,460777,1006825,785341,127448,399992,798118,778091,140664,824265,673623,774366,575205,856348,422543,503964,337456,65173,700010,92331,132466,501546,873638,22446,483365,976989,1017304,938376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]