SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037280 LIMIT 1 [ RunTime:0.001948s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037280 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585165,183077,657558,690885,754926,392959,373325,260280,455384,519792,647143,1000004,742168,659522,980329,405198,300461,772802,533573,685367,542810,1000071,86970,330244,140349,85719,111608,646924,546838,835081,408770,874600,559334,130360,26872,8111,158327,362823,966805,705118,84051,256394,413829,73628,228894,965614,527668,344653,184374,597877,430672,92812,1025186,1032289,1010942,701199,1033076,870496,912442,936133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]