SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430545 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430545 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343394,140407,472200,582458,106615,171455,866269,166933,135713,531066,84401,118384,390662,246167,992120,716266,10548,632262,496168,163990,401200,839757,91193,49178,36073,742400,713963,587775,739338,339488,71774,1030228,770110,440926,596052,471976,887533,420535,34618,425931,252588,772183,770161,809938,436953,771364,385585,680402,68451,697327,38152,167836,398163,238866,470670,444064,532900,31448,86100,377955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]