SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031371 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031371 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324977,330275,21389,489324,962113,376010,846021,101699,467081,979571,990405,486843,923154,317737,543003,475529,27895,180377,531162,199654,37335,564556,777520,770069,1029219,634170,831432,174108,245760,305114,520959,557194,329784,944687,1034405,650861,955719,769667,1019305,847213,200426,611223,639366,220784,820039,12715,195897,418513,997439,62064,316154,41639,492949,855317,426311,1003767,838555,978941,526888,988309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]