SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499005 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499005 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99112,550705,147557,240502,893996,375961,456536,686037,740707,338052,584641,208010,111013,596772,64496,808912,574476,156745,663604,175485,138356,449015,912525,447699,77973,132595,201833,759821,163170,386580,929917,549317,1032608,493527,448128,386871,1037117,436279,773282,83986,589624,427925,1003033,515181,556212,658647,1038345,885773,82615,960406,666113,116787,978583,712517,212274,479603,84613,530901,747606,111912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]