SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201807 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201807 [ RunTime:0.001495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135244,370726,736524,328611,104208,29473,85924,839554,736077,657512,415052,38396,652448,249155,185040,836018,519353,412344,387199,711716,532486,50510,928075,726705,165655,838933,777185,372095,89931,1030275,454072,858406,391894,100477,780796,327967,396293,132205,525388,990128,289938,291996,160399,522862,1014476,398009,1013670,550988,1002090,524806,477881,115727,864461,756903,950592,843060,434294,112216,91766,824433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000742s ]