SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517012 LIMIT 1 [ RunTime:0.002856s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517012 [ RunTime:0.002458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453694,872860,711209,182783,546829,875387,912190,874105,83523,354778,45334,183233,639701,1013741,757503,232306,1047709,88165,174346,407218,971064,416813,900134,1018406,816371,670955,402935,895588,342520,341977,170512,831960,267215,974993,546530,945522,949480,183744,75637,788907,96032,894901,576051,517009,136767,516580,262482,338104,1018980,319251,27889,231638,585532,507465,744358,829818,948827,364191,790157,76204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000881s ]