SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286304 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286304 [ RunTime:0.002813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886324,78263,555723,768549,230678,516655,557279,275647,436302,160339,576667,195205,559045,316087,714903,113575,1023463,539800,214078,733945,512757,37684,88790,1018725,826663,940354,137519,812410,970014,479810,160096,58358,461691,252956,527546,30395,766320,514489,958734,86895,914507,519385,941666,590894,603834,577025,193027,424572,854091,787418,775053,714808,1045653,997421,997797,596397,815827,117883,749521,644063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286304 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286304 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004450s ]