SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509272 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509272 [ RunTime:0.001958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500195,992454,919021,314649,418967,280132,253284,294073,892123,245443,732793,267889,806129,830071,189625,219260,358801,545362,645508,575042,55482,957554,855453,917668,324195,231781,556771,876291,171801,96393,349514,35203,573722,899084,21614,492519,807252,979008,515305,603654,564466,550811,110444,597747,722649,136825,859182,520,674259,880347,709619,973439,207198,559817,706019,714583,65327,945741,126697,677860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]