SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034226 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034226 [ RunTime:0.002922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830333,676107,57804,176062,1002881,169788,761997,161767,994649,717901,190032,818611,784952,149876,100224,774624,907138,348809,824279,718819,503456,949853,97123,543225,523182,367653,422145,120831,768891,598622,738970,90424,436189,11682,18938,742966,481459,380171,45887,410436,818629,988921,913478,329476,665303,517094,331979,496555,623813,915251,505947,479973,836456,615699,323821,753223,621695,1000932,629154,592936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]