SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001647s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501527 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501527 [ RunTime:0.002586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40403,325176,451315,520767,414012,126367,523817,956897,275128,134442,656460,741637,397336,224088,25526,980482,682528,65824,1001220,660678,612129,356898,304507,976452,191395,701841,69111,804618,877698,174647,901488,580360,601555,489250,496183,800026,117815,282313,609381,462521,942172,316995,35396,1038026,739626,367404,866857,320943,851398,56648,749699,132425,511828,21036,16098,1000818,843436,883680,589552,474028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008915s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001248s ]