SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 273400 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 273400 [ RunTime:0.002373s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512416,149590,228160,1038860,484133,891567,1012700,398277,484890,810843,956007,1030643,445612,750275,144763,734596,941175,346903,225925,61980,220154,61940,444779,115114,938727,440540,700498,410309,229910,952198,462474,793288,507699,906000,249969,652162,839696,882431,68998,742240,386655,467958,1010582,492770,404180,229877,206164,895195,351840,919034,24591,227614,470916,827017,951975,484925,648254,602606,198906,779372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 273400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 273400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]