SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501357 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501357 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645183,730514,764315,34459,124667,62934,995308,662187,69194,734789,978991,329121,169605,172621,416160,545122,829041,660492,297173,744520,868500,423451,79672,140414,634266,889784,481138,926925,33777,800654,865926,518716,151975,667986,259170,684155,739132,56351,350645,493511,912392,114379,587734,815603,26701,918167,29880,247989,214649,216488,86347,554350,206410,346926,344371,283647,938743,3602,839580,781301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501357 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501357 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]