SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 615100 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 615100 [ RunTime:0.002425s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318708,972720,441033,119170,1042184,1003310,1020695,977532,135255,266738,1026458,173093,36559,182199,776946,625123,268841,933218,224595,487084,175043,681565,764884,518330,423528,180141,853406,315294,273166,854384,333806,560039,226140,444759,796998,103936,861598,1030581,989752,850453,946291,207658,880405,727516,262073,615548,300967,989936,509570,103604,637397,6984,299794,308204,778576,27132,446676,33208,956309,965447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007659s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 615100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 615100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]