SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509231 LIMIT 1 [ RunTime:0.003873s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509231 [ RunTime:0.009613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97006,256133,809305,696414,890756,57499,197880,707649,138191,150634,601947,451678,862075,323755,964511,1011998,494949,493598,826832,23853,148897,972771,856206,1026417,365439,272522,957527,933921,223178,127844,401902,997078,608855,432584,706574,301312,752292,708745,582048,673098,246500,595403,799566,865308,530219,16056,987400,333218,143012,295068,344054,1027455,407245,1046057,49422,1014140,71612,484225,882953,661252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.019325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007206s ]