SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531591 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531591 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294073,727547,604783,757482,738914,622202,920455,142927,712858,737197,988432,547239,716525,932357,300552,796231,343650,701260,601651,505729,322105,358795,207598,394538,1008478,683114,577867,395006,494918,99543,803918,928465,300827,874339,139238,966906,549597,756811,615401,476317,394503,306591,143272,15782,217225,237085,60072,480921,13330,602830,625289,16482,407854,1020659,832371,4487,912996,919981,775734,288886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]