SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 949813 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 949813 [ RunTime:0.002682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993882,264968,407662,244135,771304,793873,57580,639896,125171,986754,175844,920337,914058,775974,268050,836198,150061,140068,863400,314709,785233,403387,446473,770873,953070,51586,530627,118639,88461,668829,529773,623863,569245,659426,253629,763334,589136,788044,641655,570281,565710,430644,965428,807307,160568,681597,972725,366329,797926,590496,571162,551676,396158,259734,712188,929502,704866,1012683,973988,580039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 949813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 949813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]