SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331753 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331753 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518487,834999,145964,664965,732991,595061,107048,546152,96122,788440,453110,889882,250753,776942,158923,559479,368377,309779,82848,313341,1013993,648287,303259,124776,738495,244027,1043379,333703,657931,154047,582827,357196,71941,226744,958185,827127,919401,248662,956366,14760,894263,912238,910943,264328,30517,339129,736399,331929,704438,846925,860033,786165,274472,1043355,735039,825283,47843,404700,794518,344758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]