SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105621 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105621 [ RunTime:0.001381s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570265,1042490,303641,797622,880258,21558,214826,759926,875318,1020042,239207,995015,280917,682290,271286,268323,346676,708832,410612,939398,3813,36115,775192,726485,235072,61402,30206,572561,855735,742373,853580,703576,698568,938748,579525,455818,565215,516859,456450,639934,474125,36361,783839,951690,933896,520200,267024,875389,624036,589795,934582,88513,615664,1010604,584721,534140,146060,730604,433714,664930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]