SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354272 LIMIT 1 [ RunTime:0.001400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354272 [ RunTime:0.002020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671843,945877,939877,181674,715977,450650,912072,369165,8006,133516,940859,418914,876317,805808,169933,284040,114111,728120,219522,485861,540210,699550,218648,313653,135763,659692,302022,619107,78482,900895,542288,306417,881126,245353,708825,966442,251001,152377,658043,720636,1018229,364864,456916,852428,453986,1042802,68450,363782,334088,157787,570641,122230,26565,386780,883023,934992,48461,764907,209298,10691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001762s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]