SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526208 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526208 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (758291,929210,577915,796996,593593,848937,892604,723250,944421,102353,254448,677209,55252,177345,142226,282967,997733,602851,518174,247373,435164,447916,584336,123358,420089,300682,460489,790712,190576,987494,579800,136712,81621,550806,399512,178578,367105,679716,448816,950088,4646,611298,327599,849818,213460,229836,535187,231497,775710,454384,222297,93994,285634,260285,126356,653247,900943,486531,97817,618449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]