SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 983907 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 983907 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019219,832725,128313,300735,284141,928230,918004,543958,512205,59270,321630,472556,703347,532630,322967,810331,806347,255582,351119,871235,319818,62170,607719,248103,461703,836908,343579,935763,209751,90133,545399,983362,511908,744888,597873,800005,792030,122829,679806,772778,203304,80244,249644,655279,996115,13205,681695,929735,68820,121649,413555,754139,801978,325060,95844,138194,633799,403506,816595,123270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 983907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 983907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]