SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042196 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042196 [ RunTime:0.007076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610636,570636,497498,1042050,349187,959727,120968,121914,268448,259071,1032011,326910,2349,963494,1040512,86083,851795,845158,861832,106016,917525,591821,688161,269086,673414,60810,771827,994668,719515,431379,612143,337192,1003567,833604,130089,548941,556297,141796,264222,553708,829602,790093,614626,696287,759250,920030,121634,712071,316623,820222,206053,898616,973168,284842,1039649,595118,114175,712694,622192,561180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]