SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490410 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490410 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539208,66270,532263,796604,808596,1008866,938485,895143,666724,406535,426108,624695,904205,809154,562093,325965,871138,246222,711098,89750,215350,68737,222451,979170,411476,869378,563179,967542,74576,292087,552998,608925,46940,390090,503770,1047877,532406,967589,544879,154975,2971,702204,189495,443844,878101,386312,834597,823375,788093,366990,1029401,837078,590044,591351,246284,361743,415096,777722,870912,763214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]