SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520743 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520743 [ RunTime:0.001595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998910,728541,266319,85978,150458,515005,496229,552193,855858,417435,15085,949329,951868,1020287,621609,778040,1046690,1047405,1034556,457504,349727,364998,135113,81638,894793,774815,497879,728746,903516,314866,850984,857481,113022,732361,810212,509973,224246,747365,938269,572638,336468,136640,169641,410472,1004543,129223,1034280,459168,271292,891510,485562,407521,634371,621169,108374,157614,829267,741824,435550,770656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]