SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 588871 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 588871 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (641595,374924,920708,681402,442056,753233,810699,214877,29704,772345,677361,702863,806383,696506,348971,391143,586284,363705,283929,607237,593430,1003650,397322,997669,635561,757203,256446,624773,342519,267153,846886,679700,918297,572697,148353,878989,616817,570428,274899,911087,57308,617448,642136,921853,450629,829440,971680,891358,942556,25510,1048523,319504,151567,532137,492342,71721,398620,25170,829364,984949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 588871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 588871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]