SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549972 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549972 [ RunTime:0.002965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047241,846742,860342,4278,887213,387559,1043841,539671,535296,199950,1004168,431747,699213,728584,746122,886773,334751,623698,618679,180235,566476,319310,600542,1033073,330902,131664,993527,929520,60864,290696,84520,557336,262688,1005967,872806,376872,461962,514729,330518,986494,77767,531852,138547,688653,3062,900268,159986,856398,751649,74598,396012,69892,400502,728339,181615,1003671,547246,604707,555256,690876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549972 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549972 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003957s ]