SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193594 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193594 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810273,732454,235792,1030912,542294,1035805,947858,772013,279485,599075,787665,93484,72785,286499,622076,1024241,378118,814911,780548,554619,284913,385697,713774,1000109,697518,488011,929578,544054,306157,362790,459221,335951,498669,346873,731640,961736,670465,70215,10169,1033284,648056,107378,679179,822158,553810,924051,659371,468575,456173,1047089,1004989,735647,583710,561173,786147,179649,420987,375441,379524,32465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193594 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193594 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]