SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001755s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019916 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019916 [ RunTime:0.001978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248653,951075,474890,36976,756610,111006,674899,657589,485677,865677,563113,365083,454171,829052,574027,868307,144492,141170,231927,1026247,521938,984244,386370,302576,928012,426022,972122,502677,888805,1006081,929266,411349,953176,96197,541712,883153,354381,226871,685580,182387,827679,461000,392380,336303,900357,955413,152931,829317,259544,469097,389400,732909,623521,839453,439467,834357,605502,774643,484037,622465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000702s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]