SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460710 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460710 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017006,878361,102466,541635,581596,846824,148107,719138,365398,905170,538134,912545,31634,80380,831148,1032633,1040086,220247,242671,480622,743236,555978,660254,763142,759445,1016135,528711,816704,648172,408707,62067,231774,899808,331799,71745,799611,472695,630118,293169,917436,202795,628948,1004362,608571,60379,619643,73288,778684,618427,120864,144412,335932,999294,566557,236189,270223,941339,997161,871429,816893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]