SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026247 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026247 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199021,409401,608575,1006127,33873,731942,152213,361240,39586,727506,247902,8868,81298,210298,880049,674924,241593,702257,685654,1033079,478901,300132,994934,165314,157138,661215,696400,618864,693955,67107,744537,915098,917484,609318,73733,851611,358146,59975,781386,754942,1047952,7912,948733,134495,363674,1043123,461489,903654,515498,853299,394400,519015,884623,943866,358375,340836,1035215,955111,602641,199235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026247 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]