SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 277613 LIMIT 1 [ RunTime:0.003016s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 277613 [ RunTime:0.002036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541075,172224,509179,827383,241852,743434,438402,458212,702340,554725,599506,194280,185685,1046026,491129,511346,172742,714961,201973,89745,259457,866751,909452,729385,515784,1021840,974646,327317,445924,1031583,44960,424766,503157,382462,603000,609634,170868,592125,743068,561259,753708,1009056,272340,608083,680611,865879,97766,650552,658455,1027729,308338,325030,437347,187918,818016,734652,419904,106344,539791,731803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003657s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 277613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001678s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 277613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]