SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001503s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043202 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043202 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665296,218969,177671,100835,1047912,672739,714751,342923,359375,420709,677511,12066,767054,227564,547608,551990,790463,549116,854923,23118,74047,426429,657005,637743,486125,949443,32405,108165,957845,121967,529302,47333,53578,559360,317997,778790,210985,742013,543792,747166,218304,383227,790870,342238,47606,1002596,533134,396027,40506,375428,431421,517782,66289,622207,909244,864214,197869,790090,877875,1005228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]