SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001616s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34510 LIMIT 1 [ RunTime:0.000574s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34510 [ RunTime:0.003885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502191,173516,581013,40171,797326,612290,932071,721828,975000,819155,268053,209950,712577,200861,297128,874246,289154,130962,409411,826082,346269,175024,642731,631449,361076,355967,895969,205216,204810,353616,866334,132484,87598,885616,635137,378932,996927,284321,321370,862310,688640,570255,993756,120766,864262,887158,577788,131412,931513,1000268,780132,439167,991345,523636,39064,819455,714958,38415,183841,354554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002777s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]