SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040880 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040880 [ RunTime:0.002713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853143,795446,493900,222758,881469,194874,688522,842664,944305,171955,976058,452002,661845,705640,824434,968584,187936,13008,252387,708869,609633,185741,815776,71927,516106,327001,537291,338358,930370,344034,880316,769524,323859,225637,549001,1014725,89948,803496,54698,1043630,295857,10809,312987,730848,564441,601578,730068,981069,645085,1008026,834411,430988,214029,108787,597506,608509,813538,249626,1010921,795942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002336s ]