SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351952 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351952 [ RunTime:0.002174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643598,705427,942453,4920,384210,457575,634404,81080,487802,857120,120826,766120,579364,346360,603727,123338,223328,91967,650982,951328,409358,362928,279844,242275,457914,748794,915116,934940,779351,998082,709638,653143,1013361,10693,845670,76485,636131,77735,648490,682270,940456,1037806,369078,829014,144146,554440,132303,334017,638488,1008802,912618,391384,304448,940004,458655,984473,66559,168331,698210,881768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351952 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351952 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]