SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010651 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010651 [ RunTime:0.002395s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (842850,937587,402314,79815,16789,846396,769803,152350,84751,742836,843591,765950,684357,404878,366697,205782,985892,114233,97555,624672,332325,1597,945571,337450,697512,158942,234441,321973,252718,457374,187325,725055,116139,609243,880345,378700,128379,985819,837008,529886,242911,748967,817243,571272,710954,991072,462030,718672,246051,281273,916765,119200,926165,922787,443663,226606,740054,475873,861180,844235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]