SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424705 LIMIT 1 [ RunTime:0.001032s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424705 [ RunTime:0.005612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314762,970796,967407,931660,209668,6148,1039635,118517,335115,871935,265202,289160,887060,867987,483563,1020052,1020586,574910,399645,722759,870012,300484,259047,156142,416159,573818,841180,247942,76240,292733,868334,228028,389764,608119,358945,33740,434202,528454,1028241,164813,421743,636305,510646,340438,586450,353376,387987,431043,560148,957427,5554,239906,136783,1009452,157434,982527,626387,331686,1037339,285215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424705 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424705 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001335s ]