SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004623s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477626 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477626 [ RunTime:0.005518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514506,459461,222114,381579,265251,301519,457298,610531,579023,499639,928963,817620,679586,870112,48724,414517,653386,1018891,326854,775612,1017815,479230,549351,116168,412957,582531,317485,544091,661599,488520,256767,281524,402501,311186,432450,468867,816790,426684,561555,342824,846820,82298,60347,26613,328874,504292,388231,43010,25149,356863,705055,274979,407146,69676,943002,481978,219280,437239,483416,196028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477626 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477626 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]