SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005591s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44153 LIMIT 1 [ RunTime:0.008231s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44153 [ RunTime:0.009283s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222863,50529,980628,255220,821033,142826,597877,20690,429778,809689,885590,191650,166276,171130,710988,920306,162049,470329,208553,515234,628838,572012,810715,612950,377044,667871,347264,314434,699023,538618,567784,520997,79731,182699,162756,1000181,997222,194967,197079,614660,1018123,312449,549053,367423,195714,588745,908170,978322,102854,957457,421290,338424,395703,681701,961644,11826,490832,183588,415183,551983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44153 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44153 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000743s ]