SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10480 LIMIT 1 [ RunTime:0.003464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10480 [ RunTime:0.005434s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379479,122511,814747,351032,669832,392314,888462,206160,901745,322422,981870,34875,630811,250931,213920,620419,425290,665376,556210,736803,576051,303854,14181,462854,575102,557809,295582,476124,955697,564183,886714,121884,727907,625882,938456,493491,788001,17626,375181,89339,867600,1013608,430051,414528,817134,427239,779,852080,755859,215937,761665,528826,569728,144040,786942,505706,504396,449448,727665,994101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001728s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]