SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001591s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 143688 LIMIT 1 [ RunTime:0.000595s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 143688 [ RunTime:0.003658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269981,121041,338640,29833,822137,101523,402579,296871,149443,847704,602000,40908,863067,615635,733050,405221,581479,835912,575248,881819,197427,302552,162437,474766,912767,147047,67489,781251,229471,171622,373174,773876,750406,578893,808557,688050,416390,957110,881775,353562,594022,859163,665482,795523,684643,1035811,105277,346816,784409,331160,158365,36521,219877,598427,280918,149044,769921,219715,941536,481546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 143688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 143688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]