SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 228140 LIMIT 1 [ RunTime:0.001905s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 228140 [ RunTime:0.002486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362608,988836,732749,1039993,510251,786092,1045252,202436,959719,155276,758331,730274,889121,86755,353684,880629,400174,390972,782846,261899,81497,253873,822753,709084,260288,440139,734303,856055,45111,556066,24802,718840,350817,130088,143324,188047,309138,94952,122014,591671,303848,807182,321078,619189,406201,644006,941608,808219,241570,841310,426183,703222,209341,461389,395508,640308,329629,949905,199777,473987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 228140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 228140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]