SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42148 LIMIT 1 [ RunTime:0.004074s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42148 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875705,235155,744866,638182,795537,316830,632232,551435,726208,616367,772161,484456,632011,797340,296760,934371,202851,654352,1002265,946217,67818,410832,251184,905180,933920,643459,895285,132920,189648,116847,161011,751316,718885,58330,1031876,556314,421969,777279,154654,525484,592653,841809,1032442,558666,1040067,553619,790815,31682,709857,929376,955762,580668,969995,1000160,859001,499331,856560,665279,306317,970882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]