SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542943 LIMIT 1 [ RunTime:0.001513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542943 [ RunTime:0.005252s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514600,545616,642453,1010446,323539,649741,215120,528411,271711,756122,936890,192494,408241,837195,164630,810543,409635,221923,549230,104375,246186,1034875,959011,393428,955562,724816,720162,96192,828784,962371,306594,969457,553109,904409,924553,22733,719068,111699,544325,690147,879458,884141,201421,236024,546894,432908,134335,1036032,796592,9415,928226,917595,563022,978957,420823,385136,893216,138001,98430,71485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.008786s ]