SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48601 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48601 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576977,840277,618953,595797,532400,778128,400682,894627,881462,74045,121002,10998,327035,884335,401004,279913,73795,423400,416989,367215,154773,664154,208123,991571,166538,75718,552423,50838,160832,789682,1013296,547885,646063,982370,756328,64775,582049,843682,1013218,1033028,986291,469262,272541,219288,140305,624405,410047,896907,1034422,995696,628349,512492,848631,42603,9190,833436,533526,590992,1008448,263204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]