SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416302 LIMIT 1 [ RunTime:0.001977s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416302 [ RunTime:0.004821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642037,459208,651533,770542,721121,323396,295362,138708,1006579,1001371,807877,705789,874336,152254,147741,368802,70148,1015108,420188,517676,981138,1022688,1005373,541436,364015,996779,254651,454038,276039,179116,846482,742701,635460,457714,668554,240384,917804,331393,847174,589047,233459,1007974,916401,442029,318139,530741,357108,147267,652410,912399,518967,802172,362828,643063,915373,545866,918958,834387,987833,344537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003819s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416302 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416302 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003537s ]