SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346773 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346773 [ RunTime:0.001984s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621149,675695,1037910,67151,210021,471464,624077,910570,653957,350442,849045,94914,66795,867452,437211,580374,1022636,126874,189335,170082,462881,118180,626763,401578,463800,185406,64249,921898,913240,371310,335140,735328,1034398,578238,352174,526014,887510,526525,670103,465596,580271,260596,739384,929647,358858,451733,314060,152790,545111,350418,478412,538695,1010676,705684,629043,6878,43648,165063,830697,574598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346773 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346773 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]