SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487523 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487523 [ RunTime:0.004819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129694,241589,218850,817408,583284,1008304,157741,856806,582997,94025,671022,291782,699485,314608,457982,965365,622934,725909,245210,485970,375303,949568,864832,27808,956395,1048619,693123,78538,56410,20313,872998,350578,841630,230393,544542,86663,129182,1016431,1037850,821452,567336,837701,740784,1007738,908099,779862,668837,222642,1027986,672440,616967,103199,243126,390618,516727,631516,240580,13801,544062,131715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001070s ]