SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54786 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54786 [ RunTime:0.008191s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932131,428619,544215,1015055,722027,982905,121410,765308,557260,682310,573446,399638,1006542,428552,467815,996516,949202,387666,927596,447723,477484,1013262,547744,51684,220415,277794,566002,339832,52170,513216,22186,320169,378436,1041939,816632,245045,833908,536699,326844,741797,401654,940652,120732,890496,219680,926808,233235,756554,408076,690130,419159,314736,405357,471395,510823,921523,324408,781820,786441,326885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54786 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54786 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]