SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003690 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003690 [ RunTime:0.002241s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515544,937612,492844,690803,179862,757825,313646,529695,310266,706780,563794,609190,828411,143522,719150,896018,140626,178245,886517,102520,187777,484442,24696,232646,337583,298051,331471,284628,776098,969872,407681,1039981,594070,28250,226656,495441,486433,603332,33528,650273,655903,719965,311269,778411,892714,852566,555248,431971,313561,758225,881851,870956,544369,349027,62371,39556,36260,252408,668254,380215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003690 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003690 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]