SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002417s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301844 LIMIT 1 [ RunTime:0.002167s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301844 [ RunTime:0.002791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538009,723012,183038,246655,979566,503559,701966,201499,946622,459863,231255,540082,370808,273189,61106,644119,609554,637630,967801,305885,564672,701893,847939,938213,702511,262093,25971,814538,214785,326628,781113,41600,414297,297505,808149,29196,814409,878660,700727,902976,646387,411649,463929,157844,477813,1038502,247068,657400,876377,421872,636671,25889,508475,794669,543770,98951,532702,483855,153991,785517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000690s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]