SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 988218 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 988218 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (976053,301399,300687,593722,893164,117932,272244,253004,23957,938659,852100,634028,1038260,895719,186143,1017041,29591,894555,1041352,445448,161841,440070,660778,352897,326230,503547,672932,296567,191,99686,813627,326679,582641,895611,1017743,270915,634886,555021,536438,988904,134467,224606,944498,457551,1015158,412388,693605,263305,973738,563941,529916,702328,858704,370170,151898,644488,218332,379150,615760,443373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 988218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 988218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]