SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517508 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517508 [ RunTime:0.002148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118946,993221,128084,952272,122505,353595,195376,609778,93440,685683,1001477,46980,169374,545467,914695,353746,119387,282012,110554,974627,616542,31826,952788,715715,637192,477446,552611,518603,267429,123451,873112,684679,379855,631111,529601,762729,258483,868836,637439,740233,392023,916798,845554,697735,16957,447726,580405,561352,89966,34642,809830,848212,996123,937239,703875,581359,537190,144795,617502,969206) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]